<?php
/**
 * Created by PhpStorm.
 * User: alice
 * Date: 2015/12/28
 * Time: 12:26
 */

/**
 * Class Involved_ForestNeedModel
 */

class Involved_ForestNeedModel extends BaseModel{

    protected $table = 'forest_need';

    /**
     * 获取林场需求列表
     * @author fyl
     * @date 2016-4-12
     */
    public function ForestNeedList()
    {
        return DB::table($this->table)
            ->selectRaw('sc_forest_need.product_name,sc_forest_need.number,sc_forest_need.spec
            ,sc_forest_need.supplier_name,sc_forest_need.contact,sc_forest_need.mobile,sc_forest.forest_name')
            ->leftjoin('forest','forest.forest_id','=','forest_need.forest_id')
            ->get();
    }


















}